package ossOutput;

public class OutputFileConstant {
    /*不查询是否有效
    public static String getUrlSql = "select case_entity.properties from case_entity";
    public static String getTargetUrlSql = "select target.url from target";
    public static String getUrlSqlByCase = "select case_entity.properties from " +
            "case_entity where case_entity.id = ? ";
    public static String getTargetUrlSqlByTargetId = "select target.url from " +
            "target where  target.id = ? ";
            */
/***************************************test*************************/
//查询是否有效
 public static String getUrlSql = "select c.properties from " +
 "case_entity c,visit_control v where " +
 "(v.entity_type = 'case' " +
 "AND c.id = v.entity_id " +
 "AND v.valid = 1)";
 public static String getTargetUrlSql = "select t.url from " +
 "target t,visit_control v where " +
 "(v.entity_type = 'target' " +
 "AND t.id = v.entity_id " +
 "AND v.valid = 1)";
 public static String getUrlSqlByCase = "select c.properties from " +
 "case_entity c,visit_control v where " +
 "( v.entity_type = 'case' " +
 "AND c.id = ? " +
 "AND c.id = v.entity_id " +
 "AND v.valid = 1 )";
 public static String getTargetUrlSqlByTargetId ="select t.url from " +
 "target t,visit_control v where " +
 "(v.entity_type = 'target' " +
 "AND t.id = ? " +
 "AND t.id = v.entity_id " +
 "AND v.valid = 1)";
 /**************************************************test*/
}
